alter table [performance].[issue_sale] alter column [basic_plan_name_eng] varchar(250) not null;
alter table [performance].[issue_sale] alter column [basic_plan_name_chi] nvarchar(250) not null;
alter table [performance].[issue_sale] alter column [coverage_plan_name_eng] varchar(250) not null;
alter table [performance].[issue_sale] alter column [coverage_plan_name_chi] nvarchar(250) not null;
alter table [performance].[issue_sale] alter column [policy_insured_name] nvarchar(101) not null;
alter table [performance].[issue_sale] alter column [policy_owner_name] nvarchar(101) not null;

GO

alter table [performance].[submit_sale] alter column [basic_plan_name_eng] varchar(250) not null;
alter table [performance].[submit_sale] alter column [basic_plan_name_chi] nvarchar(250) not null;
alter table [performance].[submit_sale] alter column [coverage_plan_name_eng] varchar(250) not null;
alter table [performance].[submit_sale] alter column [coverage_plan_name_chi] nvarchar(250) not null;
alter table [performance].[submit_sale] alter column [proposal_insured_name] nvarchar(101);
alter table [performance].[submit_sale] alter column [proposal_owner_name] nvarchar(101);

GO